package com.skyworth.acreate_mybatis.util;




public class SQLWmsTest {
/*	
	base_dict
	log_login
	log_operation
	map_group_function
	map_user_department
	map_user_group
	safe_department
	safe_function
	safe_group
	safe_user*/
	
	public static void main(String[] args) {
		 try {
			SqlToJavaBean t = new SqlToJavaBean();
			t.driverClass="com.mysql.cj.jdbc.Driver";
//			t.sqlURL="jdbc:mysql://172.20.248.220:3306/dmsUser?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull";
			t.sqlURL="jdbc:mysql://172.20.248.220:3306/wms?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull";
//			t.sqlURL="jdbc:mysql://172.20.212.193:3306/mes?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull";

			t.user="root";
			t.password="le98i3nf";

//			t.getTableInfo("base_dictionary");
//			t.getTableInfo("base_sap_warehouse");
//			t.getTableInfo("base_supplier");
//			t.getTableInfo("base_material");

			
//			t.getTableInfo("base_customer");
//			t.getTableInfo("base_material_batch");
//			t.getTableInfo("base_material_supplier");
//			t.getTableInfo("base_sap_warehouse");
//			t.getTableInfo("base_warehouse");
//			t.getTableInfo("base_warehouse_location");
//			t.getTableInfo("base_sap_warehouse");
//			t.getTableInfo("base_sap_warehouse");
//			t.getTableInfo("base_sap_warehouse");
			
			
//			t.getTableInfo("wms_inventory");
			
			
//			t.getTableInfo("sap_004_head");
//			t.getTableInfo("sap_004_body");
			
			
//			t.getTableInfo("sap_001_head");
//			t.getTableInfo("sap_001_body");

			
			t.getTableInfo("wms_instock");
//			t.getTableInfo("wms_instock_item");
//			t.getTableInfo("wms_instock_label");
			
			
//			t.getTableInfo("wms_shelves_task");
//			t.getTableInfo("wms_shelves_task_item");
//			t.getTableInfo("wms_shelves_task_label");
//			t.getTableInfo("wms_shelves_task_no");			
			
			
 
			
			
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	
	}
}
